Miracle Benelux

Tanel Poder is coming to Birmingham to do his seminar "Advanced Oracle Troubleshooting for DBAs and Performance Engineers" !!! Be there on 3 and 4 December 2009.

Tanel is one of the first Oracle Certified Masters in the world and an OakTable Network member. Register here for this Seminar!
We have set up a forum specially for our Masterclass / Seminars Attendees so you can get in contact with each other, get extra information, can ask questions about the material used in the classes. Information will be mailed after registration for this seminar.

Tanel Poder is an experienced consultant and trainer with deep expertise in Oracle database internals, advanced performance tuning and end to end troubleshooting. He specializes in solving complex problems spanning multiple infrastructure layers such as UNIX, Oracle, application servers and storage.

Seminar Description:

This expert-level seminar is concentrated entirely on Oracle troubleshooting - understanding what exactly is Oracle doing right now or what was it doing when the problem occurred. You will gain the skill to systematically work out the reasons for crashes, hangs, bad performance or other misbehavior. 

The seminar takes a holistic approach for end-to-end troubleshooting. It will explain the full life cycle of a database request, from database client libraries and network to Oracle database kernel and underlying OS. For each layer a troubleshooting technique is provided, along with advice on using the right tool for the right problem at the right time.

The two days are full of intensive learning, reading dumps, stack traces, network packet captures and Oracle SGA directly. You’ll be using debuggers and custom tools provided to you for real-time and post-mortem diagnosis.

The emphasis is put on practical troubleshooting, the safety comes first and many techniques are designed to require no change to database schemas or instance parameters.
As the seminar goes deep into Oracle internals, the attendees should already have good understanding of Oracle concepts and DBA tools in order to get most out of the masterclass.

Objectives:

Understand internals of core Oracle kernel components and their interaction with OS
Be proficient in systematic end-to-end troubleshooting, using the right tool for right problem
Have the ability to proactively eliminate potential database performance issues

Non-objectives:

This seminar is not a beginner database tuning course
This seminar is not an SQL tuning or CBO course
 
Prerequisites: Good understanding of general Oracle database architecture, OS commands
Duration:   2 days (4 x 1.5h sessions per day)
Costs:   1099 euro (ex VAT/BTW)

Keywords:  Oracle troubleshooting, performance tuning, internals

Target Audience: Database Administrators, Performance Engineers

Topics: 

(Copy this section to your training approval form)

• Systematic approach to troubleshooting and tuning
• Oracle, OS interaction and using OS-level tools for Oracle troubleshooting
• Using the full power of Oracle's built in instrumentation for troubleshooting
• Troubleshooting crashes, ORA-600's and complex hangs
• Troubleshooting latch and mutex contention
• Troubleshooting enqueue lock contention and deadlocks
• Troubleshooting Oracle private, shared and OS memory problems
• Troubleshooting Oracle cursor management and library cache problems
• Troubleshooting SQL execution by understanding execution plan internals and data flow
• Troubleshooting buffer cache, logical and physical I/O problems
• Troubleshooting undo errors, excessive redo and transaction related problems

For more look at the Agenda.

If you have any further questions please feel free to email annette.herruer (at) miraclebenelux.nl or call her at +31 6 41788142. 

Register here for this Seminar!